﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
/// Summary description for cls_baocao
/// </summary>
public class cls_baocao
{
	public cls_baocao()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    //// dong phi theo lop

    ///  dong phi theo khoan thoi gian
    ///  
    ///  chua dong phi av
    ///  
    ///  chua dong phi niit
    ///  
    ///  bao cao thu phi hang thang theo thoi gian hoc
    ///  
    ///  bao cao thu phi hang thang theo chuong trinh hoc
    #region Get By Chuong trinh hoc, Tu ngay, Den ngay
    public static DataTable GetByChuongtrinhhoc(string F_STTCAPLOP, DateTime tungay, DateTime denngay)
    {
        DataTable dt = new DataTable();
        DatabaseConnect connect = new DatabaseConnect();
        // Tham so
        SqlParameter[] para = new SqlParameter[1];
        para[0] = new SqlParameter("@F_STTCAPLOP", F_STTCAPLOP);
        try
        {
            dt = connect.GetSelectCommand("CAPLOP_GetById", para);
        }
        catch
        { }
        return dt;
    }
    #endregion
}